<?php
require_once dirname(__FILE__) . '/../includes/common.inc.php';
require_once dirname(__FILE__) . '/../includes/pdoorm.inc.php';

header('Content-Type: text/plain');

$sql="
CREATE TABLE `ns_v1payment` (
  `e_oid` int(12) NOT NULL AUTO_INCREMENT,
  `trackId` varchar(64) DEFAULT NULL,
  `cancelled` tinyint(1) DEFAULT NULL,
  `createdDate` int(16) DEFAULT NULL,
  `date` int(16) DEFAULT NULL,
  `amount` decimal(10,2) DEFAULT NULL,
  `method` varchar(64) DEFAULT NULL,
  `stage` int(11) DEFAULT NULL,
  `userAccount` varchar(64) DEFAULT NULL,
  `orderFlag` varchar(64) DEFAULT NULL,
  `orderTrackId` varchar(64) DEFAULT NULL,
  `orderId` int(11) DEFAULT NULL,
  `customerId` int(11) DEFAULT NULL,
  `isPdSolved` int(11) NOT NULL,
  `pdSolvedNote` varchar(1024) NOT NULL,
  `cancelledDate` int(16) NOT NULL,
  `cancelledOperator` varchar(64) NOT NULL,
  `cancelledMessage` varchar(1024) NOT NULL,
  `pdAdmAppr` tinyint(1) NOT NULL DEFAULT '0',
  `status` int(11) NOT NULL,
  PRIMARY KEY (`e_oid`)
) ENGINE=MyISAM AUTO_INCREMENT=1 DEFAULT CHARSET=utf8
";

sql_execute($sql);
